SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546713 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546713 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627451,511776,531604,158011,374537,44471,197850,786826,662815,930794,28013,942000,457192,182161,608948,306260,434003,277088,580762,182841,472523,331464,779169,652509,597723,570147,227393,689462,897017,295932,3064,155863,953978,459146,912529,98282,300631,855045,746213,639307,159923,805149,939121,1031774,286277,283394,508878,506261,771842,772892,1047436,933450,900531,596171,337926,919861,236239,575381,671071,584568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]