SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022874 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022874 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585241,899875,148254,157326,837830,45320,162995,486930,61406,607523,561774,672482,885758,348597,852823,230279,494771,112730,379907,346225,987378,443025,707575,640044,899012,916164,311074,597703,749443,921649,716769,561483,803676,1037549,865737,653016,836953,168873,503654,704228,484044,1043228,358130,397748,973733,676980,439767,30782,293688,132944,208760,522600,784694,223178,374522,590143,707337,474934,288408,654483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022874 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022874 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]