SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002548s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43748 LIMIT 1 [ RunTime:0.001024s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43748 [ RunTime:0.002939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032108,561460,437939,103912,25700,290688,106671,195811,750454,773832,620854,184580,509347,29205,460212,262370,191429,178061,458131,624932,92464,560051,780258,249884,133850,971809,93585,122024,996259,1036122,541585,979905,501668,722686,641145,585867,995133,281742,291183,553563,730200,1016123,406599,719142,922719,1010240,605324,683499,948474,281073,852596,561378,258748,960471,186571,827115,116827,831445,790268,428261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]