SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262307 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262307 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563530,912341,201048,732397,777947,202577,795957,129952,968406,786278,1011328,904142,994301,924367,860968,627568,759887,539376,573974,123500,44101,178024,1048049,1021984,630595,597125,3445,410049,954889,437677,882920,635146,225453,58539,498270,435872,980308,617085,422412,552148,9460,772030,920541,434864,30337,460255,871326,889043,384377,934541,241197,922440,918717,965881,1038432,135594,745417,283642,490795,1013885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]