SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467917 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467917 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668326,937878,571383,370279,644637,674657,690891,197665,145535,147343,640045,46876,454696,317388,845713,298389,728537,170218,915529,887549,802041,723894,475777,192674,938504,355880,946356,967533,405797,503801,670035,287338,359532,336787,44490,176370,949851,589830,437180,870246,516979,971386,317985,380861,527274,337986,934636,840797,584203,897220,373481,261314,390148,927462,815880,34651,927741,52913,256606,772341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001930s ]