SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003796s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403247 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403247 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535353,1015280,467146,594677,278692,484248,16708,501217,530939,148196,370397,401052,640873,1014824,984762,901620,310082,983595,851284,806919,916142,307828,456002,727002,924629,351854,386583,484861,625133,111597,769596,659625,550340,908902,533687,951400,227878,487846,116007,423827,38922,433340,682562,598217,886220,179032,904800,139840,639195,470842,700981,675392,357690,233734,120243,254924,405538,415461,526113,29263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]