SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280599 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280599 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293521,888286,962338,688735,407110,307426,667481,150385,842133,368898,617781,734933,429594,636140,711722,720782,84259,309908,139448,414204,355991,945964,530281,900733,56164,330617,361118,1026504,527250,445071,734796,781659,93678,169953,721447,197093,655375,606970,815659,212219,422318,724280,95007,1030014,537039,833905,1032350,726105,883802,235305,170414,899411,930344,749354,198753,167523,243345,131974,837270,597120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]