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` = 467093 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467093 [ RunTime:0.001559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756169,488823,353396,66588,341117,796654,766981,793985,1033744,542792,934875,912974,539156,933479,33258,549292,260158,867916,395870,991891,805243,789639,31986,988369,407370,218557,308656,815773,760119,789630,946456,612814,358423,1039398,916213,1037315,907883,142887,841646,929963,418044,230405,308929,591057,941129,509423,740383,357888,891619,573214,78644,587187,106395,625818,106353,245283,376259,139801,633900,947529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]