SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150512 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150512 [ RunTime:0.002415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397178,343581,710572,735811,949784,505151,137426,939496,482544,402249,1001880,684230,1041417,572933,8327,649657,720723,924652,948682,318334,846086,525155,393290,598121,564896,996112,59869,991309,788705,1011834,387527,22819,513550,412291,469011,211891,685210,815649,834410,907685,918970,166266,677426,746879,617495,284662,673424,503216,839961,912760,770295,291462,837887,104712,792395,290585,815852,641575,208059,160348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]