SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001982s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 159653 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 159653 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416040,1025332,28809,181934,336399,518080,985086,861819,146438,26255,1012686,942539,947147,561601,578293,762217,766199,824801,553630,383137,399115,1014387,694951,678808,52159,511766,14597,825341,416351,497855,942557,506622,692512,886023,320900,1038719,941589,479248,174117,482899,108944,542011,716403,155640,527084,5405,661697,587163,287642,350605,849401,630565,459304,413529,536890,939595,378638,241110,916577,1029099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 159653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000768s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 159653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]