SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 115318 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 115318 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136313,387995,429663,277390,1027439,686883,608498,312462,937612,890412,458702,904089,656663,699864,612931,448492,451475,118150,1008780,220098,523565,142984,677912,1043106,717873,813688,151955,961900,803683,546121,160289,192811,705691,403456,918212,473182,969172,328252,597985,898448,667035,688759,26615,1045853,588435,662659,810540,932833,345621,731723,331421,592266,891502,620197,815264,396120,1007718,434087,691552,535255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 115318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 115318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001286s ]