SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570851 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570851 [ RunTime:0.005046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007976,889821,374749,458463,914974,881527,736520,441133,159616,165026,277209,54850,5185,940156,739430,824364,571761,456053,1004850,111514,710460,731273,821076,182289,628112,1031414,712507,333078,122062,228228,577527,268170,1036664,926347,716709,702144,55847,181519,851551,421355,227263,453713,184510,751156,696519,356036,2709,344828,122092,969026,544537,849123,942040,649125,796940,622178,93885,102408,903438,995823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]