SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413656 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413656 [ RunTime:0.002833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818485,281333,913926,742569,484918,786728,172639,92244,554034,920515,404305,866011,768162,235049,37439,650078,769150,816318,471588,2309,499069,551006,941719,401984,935907,774131,760641,107777,635539,650952,472331,997213,545727,708776,963377,510016,68568,956945,978518,336977,280328,334754,37392,54448,315705,357881,135665,285375,496400,355538,345633,314306,552066,515888,695387,453326,951062,840194,567947,959793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]