SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469403 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469403 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510945,609437,272784,107261,944600,425050,504293,760131,592246,128459,92203,367980,416972,265486,394282,138723,219887,496351,270041,102611,897907,182138,904904,330131,893284,998740,533545,397121,803258,509295,863215,233228,377197,243766,78861,300398,626687,24442,787556,673605,1025316,352700,55156,10320,596850,420322,237020,974476,839271,131138,692201,800712,457596,703295,856011,174164,305543,445944,775386,937759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001247s ]