SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203439 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203439 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739242,424319,438924,763730,733022,1023296,558353,910235,495410,917832,254581,478063,189467,273165,201908,439621,467446,103747,189379,165573,737221,327039,1042599,870700,659737,1032890,859395,325269,70541,182859,922341,850401,374253,576361,227360,96637,313514,1021760,437143,418744,764246,807111,48711,155368,111951,49382,603749,221553,596072,539637,297644,722538,276157,582146,791815,801662,665849,120069,783324,990710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]