SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 97988 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 97988 [ RunTime:0.002462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614400,12244,788588,818007,485217,1010663,578605,870219,356732,266617,736394,627423,664786,659150,227854,28810,414437,453896,681951,85822,251438,29850,36496,435711,958435,1021808,587190,738579,280506,1759,529097,954979,275223,817533,437365,1023796,497408,445108,750653,621873,950374,272416,1020461,951514,480444,1007326,412906,495193,913809,835198,824544,489029,841543,499438,331900,634099,467962,733269,584197,641460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 97988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 97988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]