SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529308 LIMIT 1 [ RunTime:0.001176s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529308 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006197,542414,1043891,879441,1004723,713125,903178,658951,270313,983699,97311,842631,920482,499143,377870,834889,349951,861692,163970,541567,163609,281274,789461,1041418,717279,434723,334156,614380,4531,506167,783595,926617,994442,800253,728904,1033174,970294,900136,305432,341456,450685,217375,119593,970575,600373,157955,1048316,416222,803520,856438,233828,48905,32578,776124,925378,1037063,88894,684836,967037,890143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]