SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198456 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198456 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827857,375568,1031480,759378,113697,1000145,384315,1002196,327863,318769,809882,340387,623675,372361,671130,284612,780500,414224,866665,570204,539326,684251,34529,939453,490519,820791,711336,113329,449632,23973,278371,20742,448582,451678,435314,828552,328537,162452,340049,773849,936628,455185,373488,854226,870133,439338,480331,842340,838660,407453,992782,152671,1012115,139274,1006961,811539,90671,472750,226113,592625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198456 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198456 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]