SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578831 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578831 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342099,1014811,87806,550401,526329,936626,921080,1009268,932898,645131,244298,1009343,393867,328444,769998,286306,250210,213580,413973,647233,341268,241006,789510,969702,53740,955940,526870,406008,84636,351626,968598,134487,169991,476474,931969,791722,732363,195422,172882,968124,1042192,181646,88305,162103,361916,959356,267743,824229,457689,857634,56066,991047,84476,675251,340789,82611,313456,520691,138131,1030857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]