SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012018 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012018 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584055,313115,805914,198688,344832,272156,10667,410649,428847,63673,909787,134976,400199,569032,269397,503160,726025,432847,736850,113613,112379,129005,609164,379556,901552,78461,912701,981463,732250,121140,526893,195917,177071,188282,106944,474600,31468,700494,72376,170493,852044,797362,899321,198443,922904,62472,765209,553490,652370,506833,600239,814909,437718,526976,197535,353915,879724,22074,331348,228186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]