SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51160 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51160 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367229,390566,249600,796265,115988,890565,332059,43782,754766,784709,603728,315642,934872,49998,184781,989843,416248,628648,665353,377730,187372,72542,561477,155085,96935,572381,858977,200677,1006939,461861,686024,1041955,734890,484221,876769,157747,200139,439290,829968,280458,444861,58020,277350,572008,972990,386094,349322,94345,520060,882656,299620,988998,194317,1011581,306380,939978,560910,262070,125751,414867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001465s ]