SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801608 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801608 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109143,257949,580206,449858,370016,434361,536021,281,740305,64252,608427,854909,471636,840932,265310,646276,516302,786887,41250,840635,394753,252783,268186,600427,612259,682880,770060,991168,472649,1015568,116476,415036,475431,344291,361789,638680,277400,216032,390716,619259,340073,37261,376343,610750,260826,984058,143053,760165,99898,834874,723924,56677,362583,281465,162311,198018,911846,829434,695075,1029669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]