SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026173 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026173 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613780,610725,650883,989155,271638,537304,425551,563474,355288,255203,928009,553626,155151,167284,432178,514614,3645,1042767,161412,290824,101170,952929,771413,78674,285748,611983,789017,433088,354867,963032,103297,946134,949016,865099,889072,112036,530970,1040532,84119,617311,115624,684107,851907,274015,848343,867845,142990,1046891,733427,75271,909013,308795,242984,633578,190249,745867,196888,435708,668008,789393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]