SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490450 LIMIT 1 [ RunTime:0.001392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490450 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678595,810493,307573,920342,660551,308138,662248,1040785,256658,776552,260914,360105,403239,110788,839769,595902,1041750,213108,322272,164556,365330,123438,914722,105849,917542,500054,372550,279970,444732,696291,853759,880132,284892,340631,94372,866072,796772,267699,659147,598399,755754,1001356,322300,205790,161784,681715,364963,859798,123865,948324,959323,638695,241274,387569,684338,399559,661117,475032,660692,729718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]