SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493697 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493697 [ RunTime:0.002987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424117,423755,1024987,981807,440995,70653,656095,48748,284267,374614,377457,617886,846955,391967,333902,131078,114118,255160,20397,1035819,886928,942100,624282,684643,392091,243072,1011464,304667,144110,388333,584048,515626,1038026,475531,761177,556900,46021,138637,677660,32909,18383,957805,709977,465561,877592,976497,619956,468541,631725,694285,632418,350243,825677,623346,966598,686450,63439,995650,831210,104431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]