SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526412 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526412 [ RunTime:0.002287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482398,871058,496784,606934,861940,542418,11666,678283,303646,641383,1037269,948154,39600,857947,293268,325682,839118,54059,675263,276632,763348,677478,791457,537539,424394,3463,242700,38996,92379,315670,461500,621281,607352,679179,454626,913477,614157,310211,430492,885870,448627,307488,332458,232537,308663,876515,306084,129580,1040973,423099,72036,469225,598084,423663,842008,218814,824142,302496,1026631,786913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]