SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519515 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519515 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269674,787450,1038076,46616,666633,478786,305643,569556,96076,838615,606056,872643,763074,98056,765951,75198,820676,844137,737806,257879,87568,1012199,302106,350649,506039,290281,592073,112888,30355,517972,769940,945593,774672,671525,719183,863628,376795,828221,230594,440922,196340,403092,985708,16526,523568,631866,595804,778803,12205,714508,775736,775248,779577,79580,276618,685793,152531,514916,297264,504133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]