SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401861 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401861 [ RunTime:0.002760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213575,31840,625715,499858,634799,511906,296654,567753,855331,196721,388593,446038,313468,958641,229329,580573,285977,102594,395474,336009,966547,147959,740101,376351,538715,412631,610037,770600,1033492,1014906,617979,503204,542467,570720,775436,605261,996027,810563,915598,657854,831583,195167,50133,773105,1024547,600016,859387,932253,228354,616362,590508,432458,621754,28890,803583,6323,719889,107936,1032360,688223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]