SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521865 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521865 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715342,742569,718090,344349,1025510,470693,160830,68475,698287,624326,321883,648307,1042270,442425,423810,892528,554803,810022,601849,488551,674010,138081,361485,429465,572217,517419,539542,85911,875919,361956,165256,753422,505888,253587,899174,350357,8758,446890,15550,764387,479380,720403,1037553,407753,851330,1045211,826254,457568,878773,760367,274304,651424,837064,1029866,653824,699349,545050,979928,249423,140141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521865 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521865 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]