SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001691 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001691 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92813,274388,876816,202771,567401,235710,537663,262622,640035,6032,432809,672063,153678,44174,831603,410358,999595,775491,384453,395924,652855,904441,1036590,9539,785843,43498,953010,770440,1027431,761443,668271,58065,892011,225486,1047208,663482,530420,854671,679142,523789,313460,945039,431643,16635,567513,706639,275032,208963,920689,222736,500149,855855,870329,760064,372998,1039527,847282,685822,333744,809590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]