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` = 401599 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401599 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395780,924463,758341,557006,661582,43806,529432,1029522,1029411,400829,328809,860337,206676,620116,445905,1030854,258754,438643,751037,1008506,238353,78568,867556,494069,314084,523934,537040,298140,299475,355417,19111,271575,776475,819848,168590,1030617,716451,371035,221335,732137,856314,220954,760327,284620,685502,736188,775444,441193,581428,681770,810624,891411,8710,831615,731545,676568,978932,250418,790308,932032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]