SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284241 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284241 [ RunTime:0.007484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119271,42025,1019647,292615,265894,841983,664906,366221,4140,603014,208864,191449,136973,611205,474324,1015114,176219,904965,193496,783405,1030091,432131,673243,837335,506738,729210,1006244,576106,534707,476096,131610,549926,362832,359688,877152,1028579,509710,737134,648768,452073,876805,932584,572660,398406,372026,296268,34510,885089,652499,439312,828340,835029,994033,87681,416584,753413,909224,1042269,421190,895626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]