SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269713 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269713 [ RunTime:0.004437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799872,211861,476178,68871,951673,726867,93327,372825,186928,32387,83189,874191,548903,690290,1030952,606072,92015,935619,592468,237886,515524,213042,470934,460280,57692,932734,61938,830221,963117,22425,852964,647156,483324,364023,219546,731378,256280,367204,504470,767373,48079,948447,501318,464136,434421,103532,181569,164965,163924,565037,668675,545768,421400,645353,931869,516267,121082,103954,261775,328134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]