SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328047 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328047 [ RunTime:0.002472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002965,840640,36361,386351,234912,56555,794676,446750,577916,1016027,747450,227742,1004762,110632,637731,297759,1019595,639133,282821,763455,120757,801983,891059,405813,787972,316547,857995,652149,61787,141412,408233,280161,1039922,699779,734103,596652,919986,636509,535646,292313,789854,883764,783226,461866,929788,72455,884887,834005,941560,682250,451443,180453,366048,830682,74214,797052,250433,532692,682684,900024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000376s ]