SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44808 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44808 [ RunTime:0.002316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306614,718836,298519,777331,758178,218489,988091,376775,135659,119544,271184,1028554,79809,167678,583950,481411,220522,352375,1027322,512731,999525,787598,718386,705586,454409,712185,267729,582014,572126,385848,170954,95246,598403,275450,684684,950652,722693,599737,722246,200747,668237,788647,496060,860925,902310,259690,469950,220211,164146,389126,853221,690761,453852,17023,906283,655434,944062,782472,70656,840726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]