SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002560s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477916 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477916 [ RunTime:0.003023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613226,456570,516563,944730,140847,137672,127742,779243,36646,731824,227716,493237,796575,329744,858850,617032,873111,81683,1000889,888462,1009501,304516,808394,151998,207361,475737,135313,641624,275957,760335,360033,815961,326883,707248,500048,979952,96039,113785,675052,144391,300048,723080,38904,94530,949575,707374,550012,789526,829880,439256,1035397,899889,540794,327066,1045736,430056,591859,1017860,180945,758925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]