SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391455 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391455 [ RunTime:0.002857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899265,530186,898706,467384,1007734,138919,598105,13582,957307,883955,853387,501858,925789,922385,48844,747230,769622,456382,1041943,632769,65399,74544,334611,521194,464877,702346,436229,853531,296342,545630,865034,273650,391856,912774,977371,174871,107346,740936,1009278,428634,1009071,173654,594407,583404,1001095,630791,606558,601677,933062,663354,699102,131365,331187,199958,598600,357425,1036818,474031,736208,702713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]