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` = 524527 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524527 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515988,1035501,1003869,442907,237861,792268,868257,715367,443155,855041,170387,658878,963655,416008,309855,1311,128680,686522,938183,501432,880286,279471,598410,214532,491019,211164,166199,103869,73809,854619,732404,1036594,777146,193255,894520,173411,805928,86098,245415,703076,89042,100215,585585,395563,617503,798404,188672,213886,693270,2029,347492,747716,1027585,824387,299258,18615,1029082,554147,768665,802174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000356s ]