SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 180601 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 180601 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35427,20458,771774,225116,391670,479512,269541,754476,16148,807756,572926,54321,944192,205083,319013,446816,682404,494079,336987,537738,353941,253008,894705,303863,473593,28840,438659,88873,973901,256817,689990,274673,839722,823413,319420,928178,851255,205397,792097,311611,389702,494532,498239,826562,626724,541711,564491,894419,497076,178633,323203,554267,384484,922495,153638,386500,63030,507706,399442,547091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 180601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 180601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]