SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506370 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506370 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404257,520570,472403,620240,967852,310140,591561,943958,717748,142207,988725,540062,1031940,259255,831314,742645,249012,954971,226302,923198,362675,203219,208923,622684,862293,83309,425826,366431,309057,608644,38219,606583,308073,1005804,78631,1028561,682647,450296,761489,1039048,861961,138987,825056,1019160,860445,644698,176085,216993,1036290,656425,16978,919059,1007265,414530,433715,754177,437669,348959,842044,1031652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]