SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301292 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301292 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5518,399402,18255,349339,544649,614177,488890,719175,232671,200862,490628,405695,128466,116322,737714,233565,666000,476325,946220,858296,806143,230530,564393,590649,538678,795524,679712,184047,563713,378447,854286,1045193,532209,787150,116338,880030,555594,28362,564080,781990,651089,206717,750647,24076,720526,137422,1027005,675507,1046708,527780,222528,802899,460652,833307,812575,978978,90903,62847,343523,15865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]