SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40741 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40741 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471245,774757,434015,996679,603583,837147,379654,403784,619542,893831,248922,696583,503199,602055,540699,992104,922587,770479,299139,803988,915625,438336,712022,435096,1001911,930250,875517,277046,772974,982370,476883,314840,114238,442852,934557,972880,517263,946025,750510,896295,53193,912406,513442,388064,267599,164931,464305,566732,132816,1034943,333392,99582,605996,688958,338926,979794,487408,316224,353303,280946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]