SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4131 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4131 [ RunTime:0.003220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811731,277586,902124,649789,724595,845934,274166,40159,604246,436411,1010464,80661,471786,177259,916526,779404,764221,195993,541051,981388,413300,88916,997767,329971,42105,745712,372538,812738,381838,449641,368006,970854,1003679,626116,411470,843757,572060,288879,613914,725812,891278,93896,246694,638762,769156,558651,364768,13724,715413,92867,956393,601612,331467,637404,351237,154223,609935,469199,956068,1032779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]