SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469504 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469504 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448449,624367,471214,564249,282903,730275,1680,201271,194069,567155,289175,696844,768038,66226,23250,574033,1018691,941550,330849,681975,818755,820751,643403,516247,172515,671891,317372,122441,403233,740820,854251,650283,206548,848246,543245,660564,800844,630072,922759,982731,398280,75454,630890,971537,435916,825035,737432,149210,505496,975024,581457,317292,180422,359035,410125,262921,903789,45098,552802,320241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]