SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328016 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328016 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318138,629091,912495,528670,793873,666988,167718,667794,862411,240784,824657,799851,60317,131651,675680,1044997,693666,361485,249864,936046,589598,490802,818065,566232,446348,96950,899057,609678,193280,426409,996871,326890,677330,859252,966667,181423,81128,1011417,588619,517954,321385,385638,435968,386926,127706,451017,20630,40792,1031301,757450,982325,946394,854793,609461,356815,673266,379638,625561,457639,708575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]