SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002826s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539815 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539815 [ RunTime:0.002453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722774,160628,443864,280984,42658,203808,950517,549863,459051,91055,871104,447825,877951,824198,348011,202710,695064,196841,422539,122394,672355,621137,300799,755865,636347,350654,329282,688560,264068,1048181,747354,224634,1026856,783394,393284,525267,967073,184914,232707,881810,233672,208235,234123,294183,886042,209704,346491,382116,22990,949601,918809,221515,264591,425011,758270,254959,248136,787354,841367,1017668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]