SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467940 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467940 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70310,642961,849932,294349,577668,826395,566641,421375,1042923,763001,461860,294411,507804,518011,624558,899784,959306,242206,462155,145509,752789,930915,1040727,925598,262690,1033698,388732,45912,67325,336497,639381,715345,557473,103310,720157,80244,961454,680211,248673,256463,133628,917533,726803,59941,913640,2647,774152,975468,493423,964111,463598,664570,355675,467394,120207,695910,598579,512726,85733,581903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]