SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543681 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543681 [ RunTime:0.002726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987646,974562,454664,120403,977270,575974,287935,672438,479668,235154,665340,483624,1047282,523959,237831,576310,465784,835364,887160,814267,425439,841210,1021921,804075,75453,937600,640278,314277,970190,168626,1040229,389396,955714,201614,234126,215461,398028,876568,174055,116045,1045614,257121,677213,114054,876270,937370,752993,117784,255905,732092,904525,614332,112107,584285,1047887,1002942,352125,386311,568811,470681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]