SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403788 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403788 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819685,765908,130063,59978,259483,1012883,685657,896633,620564,942274,944268,224162,392907,271924,922111,281388,146699,320808,722126,612704,198689,155635,196705,1040657,214036,104773,630998,133578,300498,650564,256560,847704,704323,931949,124976,669019,676593,150959,988284,164593,839766,859030,12283,648352,81134,473903,51316,230121,624535,284697,494046,1044643,552641,1043479,119147,944558,506418,54195,315765,221898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403788 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403788 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]