SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294303 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294303 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168059,783448,371262,861554,803299,516791,958825,801116,61859,50098,119239,957599,253706,98958,515166,238740,801349,997414,403616,615413,319591,317878,135110,671517,211096,398412,242403,354563,805080,297961,939925,497861,766973,63309,117874,504749,993832,1017029,641877,929854,113264,669488,106849,976896,15523,436413,125735,140799,349121,287147,442714,391814,319973,907823,498633,660108,458652,256626,912982,373042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]