SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301618 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301618 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610189,370518,732265,12915,205558,527176,114182,262363,118741,788774,768327,640514,719089,991281,566397,394951,1031635,952544,1015735,445061,238316,216682,343478,573170,774160,84260,320606,964727,885148,879503,813131,489751,467279,861009,91049,441120,741452,623104,706990,1003106,372347,611887,321055,977661,278282,569831,975474,112001,928378,363410,136199,944405,4730,448144,868743,673311,961632,87557,951205,594581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]