SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342336 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342336 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110664,794995,398895,738264,424962,254975,279042,274484,620663,328750,792934,469531,381189,241792,592804,813966,634610,633579,292955,388276,735418,944766,791083,223689,711764,870348,579190,479149,342408,1019392,732209,433765,349430,63590,389434,311109,451679,421748,556133,233173,765272,405592,425147,97701,975902,445660,10366,450190,780085,839094,945397,81732,915536,970174,969697,940344,78348,779401,116684,475318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]