SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532482 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532482 [ RunTime:0.002641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598211,461155,531491,870894,240893,525867,1034375,731909,99864,588574,182478,342563,542068,1022899,464571,823229,110070,445520,254019,838912,566626,506578,738766,1039078,379541,655883,414494,671578,997489,273038,973308,870624,387088,966722,102868,113476,319111,945537,809932,685834,336842,731952,330798,701725,641029,661939,878152,182024,1012246,245976,264032,386472,812125,1044741,1023639,769252,514181,888834,959579,501240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]