SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502146 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502146 [ RunTime:0.002749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593987,801113,678371,894056,558856,975354,736546,543962,104629,570869,498586,325808,177394,373579,771218,347526,975791,244313,1016051,395479,123873,924910,327776,322010,54198,749426,827950,827350,700740,994549,387654,628681,760352,58048,684611,998063,250908,340923,42315,357648,389387,366698,245315,946789,730619,945512,918604,180907,636568,313858,461193,251670,300434,1026251,995286,614632,551753,700038,869276,892269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000743s ]