SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002910s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492015 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492015 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127123,543192,1000479,587735,480397,412778,562128,854092,854232,810939,1032772,491155,57528,531636,533889,262291,398022,286043,319129,466020,537243,438252,382148,634303,510639,787623,337456,72994,307939,541475,143935,780324,4873,596658,152425,103685,384495,184524,126659,129180,403615,930809,746676,766389,14515,103332,650257,348170,363258,283478,755809,793549,321023,414596,12980,997608,567238,748134,843712,13582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.014421s ]