SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 611680 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 611680 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44242,612915,909462,941582,840765,815297,804866,41188,124805,854644,415578,467292,8524,139045,708053,129432,121764,372078,353916,202019,42607,733762,825370,970850,899758,66911,981854,505497,900312,593914,413953,228116,979049,332676,794565,1041283,382712,447414,78133,371203,234217,634936,407315,367969,527229,365934,252971,692519,937242,463764,881245,74600,769439,531616,44718,840593,970253,824466,627609,182474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 611680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 611680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]