SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020515 LIMIT 1 [ RunTime:0.001670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020515 [ RunTime:0.002525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738719,744083,762774,727731,628854,799731,911245,209205,924481,202152,775324,19655,384781,235362,400870,831446,743409,276116,683446,70870,243524,231470,788154,859154,247954,993709,144348,109548,969705,758538,543453,362523,869114,530655,311016,181375,190622,722718,330813,537978,130624,268553,548496,226775,347721,216064,258746,623356,658388,277072,970215,62006,570452,515430,855803,547093,747443,632350,935309,344534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.028947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002837s ]