SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 781013 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 781013 [ RunTime:0.002842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853821,705962,190725,765688,933732,514878,399680,485613,464158,202283,275842,214183,405231,593120,890059,37842,887615,875429,715039,385990,776880,332784,359827,394798,602410,700726,531353,777208,238621,171853,240709,84478,376599,517952,461061,626048,186120,636158,686771,148688,983820,918173,35596,828161,58207,786773,17695,411462,61749,426759,1041529,590724,87400,654396,951452,696097,873676,52772,559633,306131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 781013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 781013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]