SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198323 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198323 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280907,156015,847524,132574,361704,1007023,368957,567968,298501,521649,882233,55388,780424,971521,40041,1021989,909473,147972,722701,112538,377412,355010,614512,468467,215451,1047146,231066,714710,90338,347780,279962,993804,758432,743138,23039,565104,52852,388435,3616,553124,691478,666602,980191,499468,206863,1022397,462725,603437,61237,955106,475979,915813,1013677,781000,354097,522208,129606,250178,106907,58857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]