SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 202011 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 202011 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421018,961223,645034,380966,437495,943051,332153,1026494,361202,131668,658381,186176,401380,445547,394794,265566,347756,872672,430773,364372,941170,531993,871380,715984,240463,374517,910532,551190,811361,758146,315665,519853,1012091,802231,364128,530634,578860,38732,669615,924760,817671,557166,294089,720561,878143,1033440,885109,905734,21587,194339,129190,508468,334551,157169,970381,717649,147657,850540,754021,245739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 202011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 202011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]