SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504490 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504490 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630124,200073,640955,200927,146143,583035,371976,132579,547545,194280,589452,899102,1036025,109413,811395,32270,194781,72883,902606,719644,986419,821348,229215,630138,641515,613998,362365,516586,922486,590477,1031707,78966,355539,693683,423627,375620,746100,399044,280579,237575,590469,586517,478848,913943,1036683,605890,599885,375700,198617,721964,946504,625601,107375,1026568,524741,514129,72591,101480,673209,723540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]