SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405894 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405894 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507854,96931,912303,734051,231445,536379,776030,72042,519761,763266,1034754,1035323,540690,412167,972604,370350,539998,663192,739063,953008,941941,312867,408187,275463,885538,780208,718963,786526,144932,502016,481397,712900,906451,722253,353293,522835,957362,589642,930132,8120,1017833,415096,576537,620625,980923,201840,914979,234864,907144,25254,894200,478822,52867,625175,665474,834415,964059,278863,839696,650668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]