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` = 1039604 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039604 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520220,191376,34459,66770,542190,1007292,772728,567412,710172,926597,123697,393637,119373,657159,788590,845193,422200,598929,243076,637128,651696,181008,677785,574427,188819,431909,22343,542907,992302,16538,10931,51696,938789,892018,699149,959123,591569,407826,736154,963228,312552,416979,75491,920644,945523,315387,172161,914183,52455,469273,261055,145663,258944,157287,629896,601202,95616,716576,163225,819852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]