SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45120 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45120 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565688,672320,242139,200542,831408,788180,563697,345716,655132,732147,400137,285152,555307,598849,280700,472729,275508,6328,107386,342645,163090,320929,916345,314742,934010,825799,597558,275448,404026,250307,542895,753976,53734,826201,956275,1036704,97827,832612,662948,221675,650753,150255,516864,72103,611362,138513,815053,475076,877716,432620,746270,867177,272180,100831,553236,60002,223156,50466,1024365,437002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]