SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527817 LIMIT 1 [ RunTime:0.001862s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527817 [ RunTime:0.004643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627738,516487,8076,289878,569063,989311,196340,854874,671231,861422,31555,945191,543092,531204,347445,784328,906425,1001358,659861,1023857,63064,1001246,217294,17964,989322,460345,536040,278149,698269,158928,398654,202430,450372,70485,259652,146348,593358,679016,500938,807634,1035041,872051,276102,757162,568281,739670,638260,45155,754677,40630,559664,968875,332351,337188,739718,592721,667792,545723,110063,448113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000896s ]